Adaptive Progress Indicator for Long Running SQL Queries
نویسندگان
چکیده
Percent-done progress indicators are a technique for graphically showing how much of a long task has been completed. In the database environment such information is especially important during the long-running query execution. The proposed method constructs (during the learning phase) adaptive progress indicator model analyzing influence of averaged system state (represented with attributes describing CPU, memory and disk subsystem activity) on the query response time. Experimental evaluation shows that adaptive progress indicators can enhance users' experience and productivity. Key-Words: progress indicator, query response time, long-running query
منابع مشابه
Multi-query SQL Progress Indicators
Recently, progress indicators have been proposed for SQL queries in RDBMSs. All previously proposed progress indicators consider each query in isolation, ignoring the impact simultaneously running queries have on each other’s performance. In this paper, we explore a multi-query progress indicator, which explicitly considers concurrently running queries and even queries predicted to arrive in th...
متن کاملMap Combine Map Task Split HDFS file K 1 , N 1 ( a ) Reduce Task { P 2 } { P 1 } { P 3 }
In parallel query-processing environments, accurate, time-oriented progress indicators could provide much utility to users given that queries take a very long time to complete and both interand intra-query execution times can have high variance. In these systems, query times depend on the query plans and the amount of data being processed, but also on the amount of parallelism available, the ty...
متن کاملQuery Progress Indicator for Open Source Database
Nowadays mostly database applications are based on long-running and complex queries. So it will be helpful for users to have information about progress of query execution. Recently development of percent done progress indicators has been increased. For this purpose in this paper we propose such progress indicator for multiple concurrently running queries. The main focus is on providing progress...
متن کاملKAMD: A Progress Estimator for MapReduce Pipelines
Limited user-feedback exists in cluster computing environments such as MapReduce. Accurate, time-oriented progress indicators could provide much utility to users in this domain, where job execution times can have high variance due to the amount of data being processed, the amount of parallelism available, and the types of operators (often user-defined) that perform the processing. This feedback...
متن کاملWeb-Based Collaborative Exploration and Characterization of Large Databases
Groups of people in many diverse fields face the challenge of characterizing or mining information from a large database. Typically, this exploration and characterization is done via individual long-running SQL queries with little support for collaboration among those issuing the queries. In this paper, we present a generic system for collaborative exploration of large SQL databases. Our system...
متن کامل